FaaProcessExceptionAssignment

EntityType | Independent
Logical Entity Name | FaaProcessExceptionAssignment
Default Table Name | SyServiceExceptionAssignment
Logical Only | NO
Owner | dbo
Definition |
Note |

FaaProcessExceptionAssignment Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
ExceptionHashIdentifier |  | NUMERIC(20, 0) | NO |
AssignedStaffId |  | INTEGER | YES |
AssignedStaffGroupId |  | INTEGER | YES |
ReviewStaffId |  | INTEGER | YES |
ReviewStaffGroupId |  | INTEGER | YES |
LockedByStaffId |  | INTEGER | YES |
LockedDateTime |  | DATETIME | YES |
IsReviewCompleted |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
IsEscalated |  | BIT | NO |

FaaProcessExceptionAssignment Keys

Key Name | Key Type | Keys
Nk_SyServiceExceptionAssignment_ReviewByStaffId | Inversion Entry | ReviewStaffId
Nk_SyServiceExceptionAssignment_AssignedStaffGroupId | Inversion Entry | AssignedStaffGroupId
Nk_SyServiceExceptionAssignment_AssignedStaffId | Inversion Entry | AssignedStaffId
Uk_SyServiceExceptionAssignment_ExceptionHashId | Alternate Key | ExceptionHashIdentifier
Pk_SyServiceExceptionAssignment_SyServiceExceptionAssignmentId | PrimaryKey | Id
Nk_SyServiceExceptionAssignment_UserId | Inversion Entry | LastModifiedUserId
Nk_SyServiceExceptionAssignment_LockedById | Inversion Entry | LockedByStaffId
Nk_SyServiceExceptionAssignment_ReviewByStaffGroupId | Inversion Entry | ReviewStaffGroupId

FaaProcessExceptionAssignment Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StaffGroup | Non-Identifying | Zero or One to Zero or More |  |  |  | AssignedStaffGroupId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | AssignedStaffId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | LockedByStaffId | NO
StaffGroup | Non-Identifying | Zero or One to Zero or More |  |  |  | ReviewStaffGroupId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | ReviewStaffId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaaProcessExceptionAssignment Check Constraints

Check Constraint Name | CheckConstraint

FaaProcessExceptionAssignment Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaaProcessExceptionAssignment | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyServiceExceptionAssignment | NO |  |  |

FaaProcessExceptionAssignment Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Service

FaaProcessExceptionAssignment Data Movement Rules

Name | Type | Rule Text/Value